<%@ Page Language="C#" AutoEventWireup="true" CodeFile="SqlDataSourceHttpCookiePage.aspx.cs" Inherits="SqlDataSourceHttpCookiePage" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
    <title>Untitled Page</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:RecruitVietnamDbConnectionString %>"
            SelectCommand="SELECT JobCategoryID,[RecruiterID], [JobTitle], [AdvName], [ContactEmail], [ContactPerson], [ContactTel], [City], [WorkLocation], [ClosedDate], [JobSummary], [RequiredNumber], [SalaryFrom], [SalaryTo], [Currency] FROM [tblRCJobPostings] WHERE ([JobCategoryID] = @JobCategoryID)">
            <SelectParameters>
                <asp:CookieParameter CookieName="JobCategoryID" DefaultValue="1" Name="JobCategoryID"
                    Type="Byte" />
            </SelectParameters>
        </asp:SqlDataSource>
        &nbsp;
        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataSourceID="SqlDataSource1">
            <Columns>
                <asp:BoundField DataField="JobCategoryID" HeaderText="JobCategoryID" SortExpression="JobCategoryID" />
                <asp:BoundField DataField="RecruiterID" HeaderText="RecruiterID" SortExpression="RecruiterID" />
                <asp:BoundField DataField="JobTitle" HeaderText="JobTitle" SortExpression="JobTitle" />
                <asp:BoundField DataField="AdvName" HeaderText="AdvName" SortExpression="AdvName" />
                <asp:BoundField DataField="ContactEmail" HeaderText="ContactEmail" SortExpression="ContactEmail" />
                <asp:BoundField DataField="ContactPerson" HeaderText="ContactPerson" SortExpression="ContactPerson" />
                <asp:BoundField DataField="ContactTel" HeaderText="ContactTel" SortExpression="ContactTel" />
                <asp:BoundField DataField="City" HeaderText="City" SortExpression="City" />
                <asp:BoundField DataField="WorkLocation" HeaderText="WorkLocation" SortExpression="WorkLocation" />
                <asp:BoundField DataField="ClosedDate" HeaderText="ClosedDate" SortExpression="ClosedDate" />
                <asp:BoundField DataField="JobSummary" HeaderText="JobSummary" SortExpression="JobSummary" />
                <asp:BoundField DataField="RequiredNumber" HeaderText="RequiredNumber" SortExpression="RequiredNumber" />
                <asp:BoundField DataField="SalaryFrom" HeaderText="SalaryFrom" SortExpression="SalaryFrom" />
                <asp:BoundField DataField="SalaryTo" HeaderText="SalaryTo" SortExpression="SalaryTo" />
                <asp:BoundField DataField="Currency" HeaderText="Currency" SortExpression="Currency" />
            </Columns>
        </asp:GridView>
    
    </div>
    </form>
</body>
</html>
